const connection = require('../app/database')

class FileService {
  async create(filename, mimeType, size, userId) {
    const statement = 'INSERT INTO avatar(filename, mimetype, size, user_id) VALUES(?,?,?,?)'
    const [result] = await connection.execute(statement,[filename, mimeType, size, userId])
    return result  
  }
  async queryAvatarWithUserId(userId) {
    const statement = 'SELECT * FROM avatar WHERE user_id = ?'
    const [result] = await connection.execute(statement,[userId])
    return result.pop()
  }
}

module.exports = new FileService()
